Excel to MySQL: Analytic Techniques for Business Specialization

After completing Excel to MySQL: Analytic Techniques for Business Specialization, you will be able to learn…

  • Best practices for how to use data analytics
  • Identify critical business metrics such as cash flow, profitability, and online retail marketing metrics
  • Revenue Metrics – Traditional Enterprise Sales Funnel
  • How different types of companies relate to big data culture
  • Distinguishing the Business Data Analyst and Business Analyst Roles
  • Web Marketing AdWord Metrics
  • Financial Services Metrics Money Management and Investing
  • How to use data analytics to make any company more competitive and more profitable
  • Recognize the most critical business metrics and distinguish them from mere data
  • Design and implement realistic predictive models based on data
  • Learn to calculate and apply to real-world examples the most important uncertainty measures used in business, including classification error rates, entropy of information, and confidence intervals for linear regression
  • Excel vocabulary and functions
  • Functions on Individual Cells
  • Functions on a Set of Numbers
  • Functions on Ordered Pairs of Data
  • Sorting Data in Excel
  • Calculating Positive and Negative Predictive Values
  • How to Calculate the Area Under the ROC Curve
  • How to calculate and apply entropy
  • Standard Normal Probability Distribution in Excel
  • Standardizing x and y Coordinates for Linear Regression
  • How to apply linear regression models when your input consists of multiple types of data for each event
  • Understanding Why Over-fitting Happens
  • Using SPAPs to Structure Your Thinking
  • How to streamline analyses and highlight implications efficiently using visualizations in Tableau
  • Analyzing Data-Related Salaries Over Time Using Date Hierarchies, Trend Lines and Box Plots
  • Create the most important graphs used in business analysis and transform data in Tableau
  • How to use Tableau to answer data analysis questions
  • How to Write calculations and equations in Tableau
  • How to Publish online business dashboards with Tableau
  • Designing a Dashboard to Determine Where You should Apply for Data-related Job
  • How to tell stories with data
  • How to Design effective slide presentations to showcase data
  • Clear understanding of how relational databases work
  • How relational databases work and how they are used in business analysis
  • Fundamental principles of relational database design
  • How Entity-Relationship Diagrams Work
  • How Relational Databases Help Solve Those Problems
  • How to Make Entity-Relationship Diagrams using ERDPlus
  • How to Make Relational Schemas using ERDPlus
  • How to Use two different database user interfaces
  • How to Use Jupyter Notebooks
  • How to Use Teradata Viewpoint and SQL Scratchpad
  • Strategies to manage joins between tables with duplicate rows, many-to-many relationships, and atypical configurations
  • Design and execute subqueries
  • Logical conditions into your queries using IF and CASE statements

Excel to MySQL: Analytic Techniques for Business Specialization includes 5 Courses they are

  1. Business Metrics for Data-Driven Companies
  2. Mastering Data Analysis in Excel
  3. Data Visualization and Communication with Tableau
  4. Managing Big Data with MySQL
  5. Increasing Real Estate Management Profits: Harnessing Data Analytics

Course Instructor Daniel Egger, Jana Schaich Borg & Offered by Duke University from Coursera

Course Duration: Approximately 7 months to complete (Suggested pace of 4 hours/week)

Course is for Beginner Level

Note: 100% OFF Udemy coupon codes are valid for maximum 3 days only. Look for "ENROLL NOW" button at the end of the post.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Read more about Affiliate disclosure here.
Deal Score0

Udemy Popular Instructors: Rob Percival | Phil Ebiner | 365 Careers | Chris Haroun | Colt Steele | Jose Portilla | Kirill Eremenko | Maximilian Schwarzmüller | Ben Tristem | Daragh Walsh | Evan Kimbrell | Dr. Angela Yu | Laurence Svekis | Start-Tech Academy | Mike Wheeler | Joeel & Natalie Rivera | Stephane Maarek | Hadelin de Ponteves | Tim Buchalka | Scott Duffy | Valentin Despa | Mohsen Hassan | Jaysen Batchelor | Jason Dion | KodeKloud Training | Stephen Grider | Daniel Walter Scott | Rahul Shetty | Andrei Neagoie | in28Minutes Official | Mauricio Rubio | Leila Gharani | Chris Croft | Lawrence M. Miller | Steve Ballinger | Eshant Garg | Juan Gabriel Gomila Salas | Alexander Hagmann | CADCIM Technologies | Sandeep Kumar ­ | Neil Cummings | Denis Panjuta | Tarek Roshdy | Minerva Singh | Matthew Barnett | Siva Prasad | Dr Karen E Wells | Graham Nicholls | Kain Ramsay |

Courses by Top Universities and Institutions: Google Cloud | Stanford University | Deeplearning.ai | University of Michigan | University of Illinois | IBM | Johns Hopkins University | Northwestern University | University of Minnesota | HSE University | Duke Univercity | New York Institute of Finance | Rice University | University of Washington | Yale University |
Course Coupon Club