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
- Business Metrics for Data-Driven Companies
- Mastering Data Analysis in Excel
- Data Visualization and Communication with Tableau
- Managing Big Data with MySQL
- 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
Can I download Excel to MySQL: Analytic Techniques for Business Specialization course?
You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Excel to MySQL: Analytic Techniques for Business Specialization course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.com
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 Affiliate disclosure here.
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.
