Power BI Mistakes to Avoid
Power BI Mistakes to Avoid
What you’ll learn
Skills you’ll gain
Whether you're new to Power BI or a seasoned expert, there are key mistakes you'll want to avoid in order to get the most out of Power BI, as well as the data you're working with. Packed with short actionable tips, this course covers all aspects of extracting, transforming, loading, and visualizing your data. you'll learn how to be more effective at analyzing data, how to eliminate unnecessary steps, plus ways to identify the appropriate granularity. you'll also learn how to use slicers, avoid common mistakes in charts, how to eliminate two-way relationships, and more.
Syllabus
Download syllabus-
1
Main challenges of Power BI? Microsoft Power BI has a few challenges you should be aware of. 2m
-
2
Systems thinking vs. Ad hoc analysis It's time to start using systems thinking. After watching this video, you'll be able to become a systems thinker. 2m
-
3
Being an effective analyst There are a few steps to being an effective analyst. After watching this video, you'll be able to improve your analysis skills. 3m
-
4
Keys to effective data visualization There are a few key things to using visualiations effectively. After watching this video, you'll be able to use visualization effectively. 2m
-
1
Don't pull in too much data You want to use as much data as is necessary to get the job done. After watching this video, you'll be able to pull in the right amount of data. 1m
-
2
Eliminate extra applied steps You must eliminate extra steps. After watching this video, you'll be able to limit your work to only the steps necessary. 2m
-
3
Remember to profile your data sources It's key to keep track of the profile of your data sources. After watching this video, you'll be able to keep track of your data sources. 2m
-
4
Remove unnecessary rows and columns Always remove unnecessary data. After watching this video, you'll be able to remove unnecessary data. 3m
-
1
Create a lookup table Lookup tables can help you sort through data After watching this video, you'll be able to use lookup tables effectively. 4m
-
2
Use star schema Star schema is a great way to work with data. After watching this video, you'll be able to use a star schema effectively. 1m
-
3
Eliminate two way relationships You must eliminate two way relationships when modeling. 4m
-
4
Apply user friendly value replacements There is a specific way you should do valve replacements. After watching this video, you'll be able to apply value replacements. 1m
-
5
Define the right level of granularity There is a certain level of granularity you should consider for modeling data. 2m
-
1
Visualizing time series data There is a specific way you visualize time series data. After watching this video, you'll be able to create visualizations from time series data. 1m
-
2
Use groups to break up the analysis You can use groups to break up your analysis. After watching this video, you'll be able to use groups effectively. 3m
-
3
Use slicers to improve usability Slicers are a great tool to increase visibility. After watching this video, you'll be able to use slicers effectively. 2m
-
4
Use a custom tooltip to add detail Custom tooltips can help you add detail for your visualizations. After watching this video, you'll be able to use custom tooltips. 2m
-
5
Be careful with pie charts There are some common errors you should be aware of with pie charts. After watching this video, you'll be able to correctly use pie charts. 2m
-
6
When to use Top-N analysis There is a certain time you should do a Top-N analysis. After watching this video, you'll be able to conduct a Top-N analysis. 2m
-
7
The full potential of visualizations There are many things you can do with visualizations. After watching this video, you'll be able to fully embrace visualizations. 2m
-
8
Use color sparingly It's important that you use color sparingly. After watching this video, you'll be able to use the right amount of color. 2m
-
1
Additional resources Congratulations on completing this course! 1m
Certificate
Certificate of Completion
Awarded upon successful completion of the course.
Instructor
John David Ariansen
John David Ariansen is an expert in helping organizations understand and use data. John David is the co-founder of Silvertone Analytics, a consulting firm that focuses on helping organizations with data governance, data analysis, and data-informed strategy. His specialty is data visualization, which helps take large sets of data and turn them into infographics that highlight underlying trends in the data. These trends help his clients make the right decisions. In addition to his consulting work, he also sits on the board of directors for Triad Local First, a nonprofit geared towards helping support local businesses in North Carolina. Through Triad Local First, he holds regular classes and workshops that help educate business owners in becoming more data literate. John David has a passion for education and currently sits on the advisory council at Greensboro College. He teaches data visualization and the analytics minor capstone course for Greensboro College.
John David Ariansen
Helping organizations understand and use data
Accreditations
Link to awards
How GoSkills helped Chris
I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth. Seeing how much this has helped me become a more efficient employee is a big motivation.
