Python I for Power BI Users
Dramatically enhance Power BI's capabilities by incorporating Python's flexible and powerful data wrangling, data analysis and data visualization functionality
An outline of this training course
Despite the benefits, many people are hesitant to really dive into Python, thinking it will be difficult to learn and implement in practical ways. In actuality, Python is easily understandable, very flexible and even beginning users can perform powerful analyses that are difficult or impossible with Power BI only. Knowledge of Python will allow you to create high-level statistical analyses and solve complicated problems with simple functions and algorithms. Combining these capabilities with Power BI's strengths provides the ultimate analytical tool, and this course gives you the ability to effectively leverage that wider range of capabilities to generate incredible reports.
In this course by Gaelim Holland, before diving in to the Python analyses, data transformations and visualization, he starts first with principles and best practices in setting up Python in a "clean environment" to minimize potential conflicts with Power BI. He then explains how to download and utilize 2 different integrated development environments to write, test and debug your Python scripts. He also highlights the best packages to use within Python from both a functional and compatibility standpoint. All of this provides you a rock-solid foundation for using Python effectively.
Details of what you will learn during this course
What you get with the course
• Resource pack of three datasets and one pbix file for practical application
For a list of all courses available through Enterprise DNA view here
- Innovative Data Analyst and Digital Channel Optimization Specialist with thorough knowledge of Omni channel analytics and incorporating online and offline data in funnel analysis.
- Skilled in maximizing online sales, revenue, and call-to-actions through conversion rate optimization, statistical science, and A/B testing. Deep expertise in statistical testing tools, data extraction, and data science.
- My 15 year career has allowed me to work in multiple data science roles in several industries at organizations from the startup level to Fortune 500 companies across 3 continents.
StartInstalling Anaconda (10:18)
StartDictionary and Dataframe (19:39)
StartDataframe Functions (12:07)
StartVisualizing Data (27:26)
StartThree Ways to Use Python Scripting (22:23)
StartPython Visuals and Spyder IDE (23:12)
StartDate Tables and Python (28:13)
StartCombining Data and Filtering (45:46)
StartPython Enhanced Report A (46:26)
StartPython Enhanced Report B (18:01)
Frequently Asked Questions
Passionate about empowering users of Power BI
"My goal is to teach others that you have almost unlimited analytical power when harnessing all the features in Power BI.
Through training across a number of different mediums, I've reached over 100,000 Power BI users, showing them a range of tips and tricks in Power BI development.
I'm a true believer that Power BI is the future of analysis and know individuals with the right training can now create advanced analytics in a scalable way that can have a real impact in the way insights are found and consumed within organisations."
Sam McKay, CFA - Founder & CEO, Enterprise DNA