Menu
I am highly skilled at Microsoft Power Bi report and dashboard development: offering unparalleled layouts, slick UI designs, and deep statistical analysis unlocking business intelligence insights utilizing advanced visualizations. I can code highly advanced DAX and M-Code in Power Query. No report is too large or too small. From complex 20+ table data models engineered from data in Azure to ingesting single Excel files. Using advanced SQL and / or Python I can construct data models and ETL pipelines from a variety of databases, from Salesforce and Snowflake to SQL databases in Azure.
JGAnalytics is my personal portfolio, data brand and side business.
Originally educated as a programmer analyst, I found my passion later in life for data analytics. I have taken courses at Ryerson University in their predictive analytics program, worked at a cutting edge SaaS tech startup in the U.S. and attended and completed a data science certification at the University of Waterloo. I have also dabbled, as a hobby, in Django web application development.
Utilizing advanced DAX coding I offer highly customized report page layouts and visualizations. I can construct advanced data models entailing 20+ tables. No database is too large or too small to be modeled. I am very talented at telling a story with data. Do you want a company branded and themed Power Bi dashboard? I can hand code theme files using JSON for an unparalleled look and feel. Not only will your report unlock business intelligence insights, but it will look and function amazingly while doing so.
I design & develop all Power Bi dashboards to provide business insights. From maximizing revenue through analysis of expenses, profit and trends over time. To optimizing efficiency of departmental functions and ensuring and tracking how your business is performing against service level agreements. As well as employee productivity and customer experience insights.
I possess advanced skills in traditional statistical analysis. Enabling me to uncover meaningful insights from complex datasets. I am proficient in using statistical software such as R, and Python to perform detailed data analysis and visualization. I excel in incorporating key performance indicators (KPIs) and relevant statistics into business analysis and Power BI dashboards, transforming raw data into actionable insights that drive business success.
As an experienced data engineer, I leverage advanced Python skills to design and implement robust data pipelines and ETL processes. My expertise includes using Python libraries such as Pandas, NumPy, and PySpark for intricate data transformations and thorough data cleaning. I excel in building scalable data architectures, optimizing data storage solutions, and integrating various data sources to ensure seamless data flow. I am particularly talented at connecting disparate data sources, enabling comprehensive and cohesive data analysis. My proficiency in Python empowers me to transform complex, messy datasets into clean, actionable insights, driving data-driven decision-making and enhancing business intelligence.
Using Python and the scikit-learn library I can engineer predictive models using supervised or unsupervised algorithms. Categorical prediction (Logistic regression), linear regression, Clustering (For highly complicated segmentation), and Text Classification using NLP (Natural language processing). *Beware: Building predictive models is a very sensitive engineering feat that requires an impeccable dataset possessing all influencing attributes with the correct historical accuracy. And that these attributes influence to the target variable makes sense in the real world (correlation does not mean causation), to ensure that the model will be statistically relevant.
Skilled in data engineering using snowflake. My expertise includes complex query writing, database design, and performance tuning, ensuring efficient data retrieval and manipulation. Utilizing data warehousing, ETL processes, pipeline creation, integrations with Azure, AWS, and GCP. Combining Microsoft Power BI and SQL enables enhanced insights, efficient use of data resources, and unlocks Power BI’s handling of big data through the use of direct query & live connections.
Attention! Power Bi reports are best viewed on at least a tablet and will not display correctly or be very usable while viewing on a cell phone.
* Disclaimer:All data contained within these reports is fictional or available for public consumption. Some data is generated using the Python library Faker.
A dashboard that showcases an amazing layout and functionality combined with Pareto Analysis of product and model sales sliced by regions.
A great example of innovative layout & design utilizing ChatGPT for productivity, and advanced DAX for conditional formatting.
Analytics on fictious U.K. railway data: tickets, revenue, cancelled, and route volume analysis. Peak periods analysis and a unique network flow graph.
Call center report that offers advanced KPI trends, volume, employee productivity and customer satisfaction analysis. Advanced custom SVG graphs.
Analytics on sports team injuries. Single page report with inline pages utilizing advanced bookmarking & intuitive layout.
This is a multi page report that provides analytics on product sales, revenue, and returns. For a single retail store.
This is a single page power bi report that analyzes Canada’s electricity consumption by province and type. One of my 1st solo projects.
ER diagram depicting attributes, tables, relationships, primary keys, cardinality and ordinality.
Statistical analysis of the survivability of Titanic passengers using Python & the Pandas library.
Logistic regression model that predicts credit card defaults from credit bureau data.
The application and dissection of the linear regression model using the Python library statsmodel.
Usage of K-Means clustering to segment customers based on electricity demand.
Decision Tree & Ensemble Methods. This project tracks and scores different model configurations.
Welcome to JGAnalytics, we offer services for hire for Data Analytics, Data Engineering, and Machine Learning.
Copyright © JGAnalytics 2024