Presented at #sqlpass summit 2015.
You have your SQL Server Reporting Services environment in native mode — and you want to modify the data source of a report there.
- Navigate to Report Manager.
- Navigate to the Report that you want to Manage and run it
- After the report renders, you will have a breadcrumb navigation on the top right
- Click on the Last Part of the Breadcrumb Navigation
- It should open up the “properties” section of this report
- On the properties section, you should be able to manage the data source
- Make the changes that you wanted to the data source settings of this SSRS report — and don’t forget to click “apply”
Author: Paras Doshi
I was talking with a database administrator about different categories that SQL Commands fall into — and I thought it would be great to document here. So here you go:
|DML||Data Manipulation Language: SQL Statements that affect records in a table.||SELECT, INSERT, UPDATE, DELETE|
|DDL||Data Definition Language: SQL Statements that create/alter a table structure||CREATE, ALTER, DROP|
|DCL||Data Control Language: SQL Statements that control the level of access that users have on database objects||GRANT, REVOKE|
|TCL||Transaction Control Language: SQL Statements that help you maintain the integrity of data by allowing control over transactions||COMMIT, ROLLBACK|
BONUS (Advance) QUESTION:
Is Truncate SQL command a DDL or DML? Please use comment section!
Author: Paras Doshi
Are you trying to import an Excel file into SQL Server using SQL Server Integration services…And ran into error that has words like “Non unicode” and “unicode”? Then this blog is for you.
Why does this error occur?
Well it turns out that things like SQL Server and Excel have encoding standards that they follow which provides them a way to process, exchange & store data. BUT turns out that SQL Server and Excel use different standards.
So, the solution is simple right? Import the data from Excel into non-Unicode format because that’s what you need for SQL Server.
So how do you that? Between your Source and Destination tasks, include a task called “Data conversion” and do the following for all columns that have text:
And in the destination task, you’ll have to make sure that the mapping section using the new output aliases that you defined in the “data conversion” step.
In this post, we learned about how to solve a common error that pops up when you try to import excel file to sql server using SSIS. Hope that helps.
Author: Paras Doshi
Here’s a link to download the Titanic data — http://lib.stat.cmu.edu/S/Harrell/data/descriptions/titanic.html — it’s really useful in analytics and data science projects. You can:
- Build a predictive model. Example: https://www.kaggle.com/c/titanic
- I also use this data set to create interactive dashboards on tools like Qlik and Tableau to understand their features.
If you liked this, you may also like other data sets that I have here: http://parasdoshi.com/2012/07/31/where-can-we-find-datasets-that-we-can-play-with-for-business-intelligence-data-mining-data-analysis-projects/
I spend a lot of time writing SQL code — and as a reader of this blog, You might be in the same boat. So any productivity gains that we could get here could go a long way. On that note, here’s a quick productivity tip: Learn to comment/uncomment multiple lines of SQL code using keyboard shortcut.
If you are using SQL Server Management Studio, it’s “CTRL-K followed by CTRL+C” for commenting AND “CTRL+K followed by CTRL+U” for uncommenting.
If you are using some other Data Management Software tool, I am sure you can find it using their HELP section or googling around.
Either ways, these shortcuts go a long way in making you more productive! What is your favorite productivity tip?
(This post first appeared on the Qlik Community. here)
So you just joined a Business Intelligence Team and one of the responsibilities include building apps for your business users. Eventually, you would have a need to see Data Load editor scripts for apps developed by other members in the team. So what permission do you need to be able to do that?
Qliksense Version: Enterprise Server 2.0
This a two-step process.
1) Get “content admin” access (or “higher” level access)
2) Double check if you have access to see data load scripts for ALL apps
The short answer is that you need “Content Admin” permission from your Qlik sense admin…But with this access level, you will have access to other developer’s app via QMC. If you need to do this via HUB as well then you will have to change the content admin role.
Here’s how Serhan ( darkhorse ) explained how to get this done:
QMC–> Security Rules–>Content Admin–> Edit–> Context–> Both in Hub and QMC
Now, once you get the “content” admin access, you might want to double two things:
1) You can get access to data load scripts on published apps — (I was able to do this but there still seems to some open questions around some folks not being able to see the data load scripts for published apps. If this is the case for you, you need to duplicate the app on your “my work” area and see the scripts)
2) You can duplicate apps on your “my Work” area and see scripts — this is also useful if you want to make changes to published apps that are out there.
I hope this helps you resolve the permission issues and help you collaborate with your team members!
I saw this ad on a highway earlier today and my reaction: why would I switch to a network that has just “96%” coverage.
…instead of converting a potential buyer, this ad actually made me more nervous. You know why? Its a case of what I like to call “data puking” where you throw bunch of numbers/stats/data at someone hoping that they will take action based off of it. So what would have helped in this ad? It would have been great to see it compared against someone else. Something like: we have the largest coverage compared to xyz. My ATT connection is spotty in downtown areas so if it said something like we have 96% coverage compared to ATT’s 80% then I would have been much more likely to make the switch.
I wrote about this adding benchmark in your analysis here
Takeaway from this blog: don’t throw data points at your customers. Give them the context and guide them through the actions that you want them to take.
I like using spark lines data viz when it makes sense! It’s a great way to visualize trends in the data without taking too much space. Now, I knew how to add sparklines in Excel but recently, I wanted to use that on Google sheet and I had to figure it out so here are my notes:
1. Google has an inbuilt function called “SPARKLINE” to do this.
2. Sample usage: =SPARKLINE(B2:G2) — by default you can put line chart in your cells.
3. Then there are other options including changing the chart type. You can find them documented here: https://support.google.com/docs/answer/3093289
4. One of the best practices that I advocate when you spark-line to “compare” trends is to make sure that you have the consistent axis definition. So the sample usage for that could like this:
(if you want to do this for excel then here’s the post: http://parasdoshi.com/2015/03/10/how-to-assign-same-axis-values-to-a-group-of-spark-lines-in-excel/ )
After you’re done, here’s what a finished version could like on Google sheet:
Here’s the working google sheet: https://docs.google.com/a/parasdoshi.com/spreadsheets/d/1EJYDTxOifeEL-YwW1a0oxXw7tFG1iAVQlwjo4EU8R-s/edit?usp=sharing