Introduction to Career Skills in Data Analytics (2022)
2h 22mBeginner2022-08-12
Authors

Robin Hunt
Developer and Educator
Course details
Are you ready to take the first step on your journey as a data analyst? Whatever your goals, you don’t need a background in computer science to get started today. In this course, instructor Robin Hunt gives you a comprehensive, behind-the-scenes look at what it’s really like to be a data analyst, from wielding data concepts and business intelligence skills, to landing your first role and advancing your career.
Explore the power of data and data analysis to develop a better understanding of the role. Learn about business intelligence, data-driven decision-making, data collection methods, discovery, and interpretation, as well as how to structure, assess, and transform data using core functions in Excel and Power BI. Gather insights from Robin on modeling, visualization, and mapping out the job market as an early-career analyst. By the end of this course, you’ll have the skills you need to set out on a new career path and tackle the Microsoft GSI Data Analytics certification exam.
Explore the power of data and data analysis to develop a better understanding of the role. Learn about business intelligence, data-driven decision-making, data collection methods, discovery, and interpretation, as well as how to structure, assess, and transform data using core functions in Excel and Power BI. Gather insights from Robin on modeling, visualization, and mapping out the job market as an early-career analyst. By the end of this course, you’ll have the skills you need to set out on a new career path and tackle the Microsoft GSI Data Analytics certification exam.
Skills covered
Tech Career SkillsData AnalysisCybersecurityCloud ComputingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsSoftware DevelopmentOne-Off
Concepts
Introduction
- Starting out with data analytics
Introduction to Data and Data Analysis
- Defining data analysis and roles in data analysis
- Developing data fluency
- Understanding how data governance impacts the data analyst
- Understanding the importance of data quality
Introduction to Business Intelligence
- What is BI and the value to business
- How are business analytics and BI different
- How data can provide intelligence to the organization
Identifying Data
- Understanding the value of data-driven decision-making
- Questioning techniques to collect the right data
- Discovering and interpreting existing data
- Data sources and structures
Preparing Data
- Describing data best practices
- Assessing and adapting the data for transformation
- Understanding the rules of the data
- Tips on preparing the data in Excel
Transforming Data
- Transforming data in Excel with Power Query
- Transforming data in SQL
- Transforming data in Power BI
- Common cleaning and transformation
- Using built-in functions
Modeling Data
- Relational databases
- Modeling data for Power BI
- Master data management
- Unstructured data
Visualizing Data
- Visualization methods and best practices
- Creating reports to visualize your data over pages
- Creating a dashboards for reporting
- Gathering requirements for visualizations
- Presenting data challenges effectively to others
- Finalizing dashboards
- Adding dashboard filters
- Modifying dashboard tooltips
Job Mapping in the Data Analytics Field
- Data workers
- Data analysts
- Data engineers
- Data scientists
Continuing Your Data Analytics Learning Journey
- Next steps and additional resources