Training overview
Professional Course
19 hours
From 1,800 USD
Start dates
Online
1,800 USD
7/13/2021

Online
1,800 USD
10/5/2021

Online
Virtual training available for teams

Worldwide
On-site training available for teams
Power BI is must have skill for category managers and business analysts. If you analyze data for Walmart, Target, Amazon or any large retailer then you should be using Power BI.

Course description

Power BI

Discover Power BI's ability to aggregate disparate data for easy reporting, visualization, and analysis. Learn about three critical process steps to create the final product – interactive reports and dashboards:

  • Data Shaping – retrieving/importing data from multiple sources, shaping and cleaning data for analyses
  • Data Modeling – adding measures and custom calculations to expand the analytical opportunities
  • Data Visualization – creating the reports, visualizations and dashboard tools for dynamic analysis

Delta’s Power BI course will bring the learner through all three process steps using real-life consumer packaged goods (CPG) data (IRI, Nielsen, NPD, SPINS, Retail Link, internal sources, etc.) and business scenarios that answer CPG-centric Business Management Questions™. By the end of the 18-hour program, the learner will be able to create dynamic and robust reports, templates and dashboards.

Below is a high-level outline of the key tools taught in each section:

  1. 1. Data Shaping (Excel Power Query and Power BI Query Editor)
    • Connect to various types of data sources like Excel, Text/CSV, databases, and multiple files in a folder.
    • Clean up “messy” data with options like Trim, Split Columns, Replace Errors, etc.
    • Convert horizontal data (time across) to vertical data (or long data).
    • Merge columns and queries like Excel CONCATENATE and VLOOKUP.
    • Append multiple queries to create a single data source.
  1. 2. Data Modeling and Measures (Excel Power Pivot and Power BI)
    • Learn best practices for setting up a good data model.
    • Create relationships in data.
    • Introduce common DAX measures and replicate common formulas used in Excel.
    • Apply advanced DAX measures such as CALCULATE, ALL and FILTER to create measures such as: This Year %Mix, Last Year % Mix, Mix Point Change and Mix Value Change.
    • Create commonly used time-intelligent measures from daily or weekly data: This Year and Last Year (Last 4 Weeks, Last 13, Last 52, and Year-to-Date).
  1. 3. Data Visualization – Dashboard Design (Power BI)
    • Add basic visual objects - Text, Images, Cards and Tables.
    • Incorporate basic chart visuals - column, bar and line charts.
    • Control various formats of values and settings within each object.
    • Create drilldown level reporting.
    • Develop multiple report pages for extensive business review.
    • Publish and share dashboards.
Want to find out more?

Training content

This is a structured curriculum with live instructor interactions. The course was designed with consultation from Mike Carlo, a Power BI Microsoft MVP and owner of PowerBI.tips. No more wasting time trying to find the right YouTube video.

Data Shaping

  • Connect to various types of data sources like Excel, Text/CSV, Databases, and multiple files in a folder.
  • Clean up "messy" data with options like Trim, Split columns, Replace errors, etc.
  • Convert horizontal data (time across) to vertical data (or long data).
  • Merge columns and queries like Excel CONCATENATE and VLOOKUP.
  • Append multiple queries to create a single data source.

Data Modeling

  • Learn best practices for setting up a good data model.
  • Create relationships in data.
  • Introduce common DAX measures and replicate common formulas used in Excel.
  • Apply advanced DAX measures such as CALCULATE, ALL and FILTER to create measures such as: This Year %Mix, Last Year %Mix, Mix Point Change and Mix Value Change.
  • Create commonly used time intelligent measures from daily or weekly data: This Year and Last Year (Last 4 Weeks, Last 14, Last 52, and Year-to-Date).

Data Visualization

  • Add basic visual objects - Text, Images, Cards and Tables.
  • Incorporate basic chart visuals - column, bar and line charts.
  • Control various formats of values and settings within each object.
  • Create drill-down level reporting.
  • Develop multiple report pages for extensive business review.
  • Publish and share dashboards.

Course delivery details

This course consists of six 3-hour sessions + one hour of 1:1 personal consulting/coaching time.

The listed events are the start days. There are 6 days of classes, each session lasting 3-hours. Our website will specify all class days.

Costs

$1,800 per person.

If you have a group of 10 or more, please contact the provider about discounted pricing and customization.

Why choose Delta Associates?

25+ years, 500+ clients in 50+ Countries

Over 5,000 certified analysts trained

Retail FMCG/CPG experts focusing on Category Management Analytics

About Delta Associates

Delta Associates

25+ years, 500+ clients, 50+ countries – We teach retail professionals how to analyze sales and marketing data, find the key insights, and communicate them powerfully and clearly. Most organizations consider data a strategic asset - yet fail to build...


Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about Power BI.

  Contact the provider

  Get more information

  Register your interest

Contact info

Delta Associates

111 Mountain Brook Drive
Suite 204
30115 Canton Georgia

 Show phone number
www.delta-assoc.com

Reviews

Average rating 5

Based on 9 reviews.

Vilay Thanadabouth
(5)
This course really helped me learn to navigate power bi, power pivots, and power query. I was able pick up on how calculations work and visualize huge amounts of data. I had zero experience prior to the training and now I leverage it more than excel! If you have large data sets, this course will help you find your golden nuggets, bleeders, and l...
Show more
Amanda Hollins
(5)
The Power Training led by Sterling Woodard has presented me with new and powerful tools to use in my everyday reporting. Sterling is always very thorough in his presentation and very responsive when questions arise. Sterling broke down the course well – focusing on each individual component – PowerQuery, PowerPivot, and PowerBI and identifying h...
Show more
E. Riner
(5)
Power BI is a powerful tool that can be so helpful to know and use, but trying to learn the basics via YouTube or blogs just doesn’t cut it. Sterling really brings the stress level down to where it all starts to click. These people know the type of data the businesses are trying to crunch because they have worked and consulted with a majority of...
Show more
Request Information

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available