I signed up for this the other day Advancing Data & Analytics Potential Together: Adapt and received an email with a license code. I'm going to start playing around with it today.
BI Dev/Data Analyst/Data Science and Careers (Official Discussion Thread)
- Thread starter Secure Da Bag
- Start date
Secure Da Bag
Veteran
Please let us know if the class or the software is worth getting into.
Secure Da Bag
Veteran
Started this class over the weekend and now on Lab 3. 
The software is like others I have used before. It's just different names for some of the tools, but many of the same functions. I have seen a few job postings utilizing the cert/ software (just general search), and they seem to have a good network.
Mindfield333
Superstar
I’m in the middle of the coursera joint right now. Anybody changed their profession to a data science discipline recently?
Secure Da Bag
Veteran
I'm about to get into some serious fukkery with Power Query/M. Use PQM as a low-rent SSIS brehs. 
Do yall typically clean data through SQL or Power BI? I'm trying to decide on a process for a personal project. The data is going to end up in Power BI and it is easier to automate in Power BI but I feel like I should be using SQL for some reason.... I don't have any scripts written so PBI's automation is easier to understand for now. Perhaps I can extract the data to SQL Server as a backup?
Secure Da Bag
Veteran
I normally clean data with SQL/SSIS. I've never done it in Power BI. This will be my project doing so. As my boss says, "in theory this should be easy".
If a company is using SQL server as a data source, the data should already be cleaned, most likely via SSIS BEFORE it’s loaded in the database. Since it’s just a personal project, use query editor.
My company has a Reporting team responsible for loading the data, so I just query data and don't know a lick of SSIS lol.
With this data, it is just some stuff online on my personal computer but it is refreshed daily during the week. I have a manual workflow workaround that I've been working on automating for the last few hours:
- Manually copy/paste the data from Google Sheets to Excel
- Run a Macro to clean up/standardize it.
- The macro also outputs a datestamped csv file... From there, I think there has to be some capabilities for SQL to locally scan a folder and import new files?
That feeling when you just spent 5 hours on a task and then find an online solution that takes less than 45 minutes
Secure Da Bag
Veteran
I believe SSIS has some functionality that will allow you to import new files.
I didn't know that Power BI could scrape websites.
I didn't know that Power BI could scrape websites.
Jumping back in Power BI after a hiatus. My job requires me to make Cubes in Visual Studio and then import that to Power BI. Still wrapping my head around the entire process.
TheAnalyst504
Rookie
Coli Brehs,
Do any of you have experience with data analysis using Tableau or PowerBI?
I'm looking for a set of assignments to help display competency using of those platforms.
Do any of you have experience with data analysis using Tableau or PowerBI?
I'm looking for a set of assignments to help display competency using of those platforms.