Has anyone here taking the MCSA 70-778 or 70-779? If so, what are your recommendations on study materials or general review?
BI Dev/Data Analyst/Data Science and Careers (Official Discussion Thread)
- Thread starter Secure Da Bag
- Start date
606onit
Superstar
I feel that I'm almost ready to pass an SQL interview. Can anyone tell me what it's like once you get in these environments? Next Im just trying to master SSIS and SSRS.
Secure Da Bag
Veteran
Depends on the company really. You might be doing a lot of DBA work or query analyzing, or stored procedure writing.
SSIS and SSRS are completely different from tsql and completely different from each other.
606onit
Superstar
Oh yeah. My study group watched this lab yesterday. We're currently studying SQL (refining ourseleves) but to break up the monotony we checked out some SSIS.....Totally understand they're differnt (although interwoven) tho
Lab1)
I'm not a "data scientist" but my job is to analyze data and look for ways to improve processes / increase efficiency / cut costs. Some of it is just mindlessly sending people charts/data that they don't use...But we do go further and try to come up with ways of turning the data into something that's actionable.
Ok so Microsoft is sunsetting it's MCSA certifications (among others) on 6/30. I'm looking to get certified to pad my resume post-recession and so I want to squeeze it in and be able to put it on my resume.
A lot of posts online suggest that the free edX Power BI course (Analyzing and Visualizing Data with Power BI) is pretty straightforward and goes a long way in terms of the Microsoft's Power BI test.
The next cohort starts 4/1. I have signed up & will be tackling it in between working from home. If anyone is interested and wants to do it together, let me know and I'll start a group chat! As far as I know, the only prerequisite for the course is a minimal understand of Excel.
Given the Microsoft owns/advertises Power BI, it has a leg up over the competition in terms of being widely accepted by future employers so I hope that someone else wants to do it with me.
Here's an intro to Power BI:
A lot of posts online suggest that the free edX Power BI course (Analyzing and Visualizing Data with Power BI) is pretty straightforward and goes a long way in terms of the Microsoft's Power BI test.
The next cohort starts 4/1. I have signed up & will be tackling it in between working from home. If anyone is interested and wants to do it together, let me know and I'll start a group chat! As far as I know, the only prerequisite for the course is a minimal understand of Excel.
Given the Microsoft owns/advertises Power BI, it has a leg up over the competition in terms of being widely accepted by future employers so I hope that someone else wants to do it with me.
Here's an intro to Power BI:
Glad to have you aboard breh
Thanks, im signing up for this
Salute breh
The course starts tomorrow if anyone else wants to join!
https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi-2
https://www.edx.org/course/analyzing-and-visualizing-data-with-power-bi-2
This website is free until april 14th
Homepage
They added a powerbi section that can probably be completed in a day or two.
@Secure Da Bag
Secure Da Bag
Veteran
This website is free until april 14th
Homepage
They added a powerbi section that can probably be completed in a day or two.
@Secure Da Bag
I wish I could find a site just like that but concentrated on PowerBI and F# as well.
Last edited:
This site has a lot of info for free:
I wish I could find a site just like that but concentrated on PowerBI and F# as well.
Videos - SQLBI
They also have a more structured course available but they will try to nudge you towards buying in-person seminars/onDemand videos:
DAX - SQLBI
DAX - SQLBI